package com.yl.auth.mapper;

import com.yl.auth.entity.Tigejiancha;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author L
 * @since 2023-07-25
 */
public interface TigejianchaMapper extends BaseMapper<Tigejiancha> {

    @Select("select * from tigejiancha tg left JOIN laoren l on l.id=tg.laoren_id where  l.id=#{id}")
    Tigejiancha getTige(@Param("id") Long id);
}
